package com.tencent.wxcloudrun.mapper;

import com.tencent.wxcloudrun.dto.Odersubscription;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Entity com.tencent.wxcloudrun.dto.Odersubscription
 */
@Mapper
public interface OdersubscriptionMapper {
    @Select("select * from odersubscription where mobile = #{mobile} and status = 1 order by paytime desc limit 1 ")
    List<Odersubscription> selectList(String mobile);
    @Insert("insert into odersubscription (id, mobile, subscriptionid, paytime,money) values (#{orderIdByTime}, #{mobile}, #{subscriptionid}, #{start},#{price}) ")
    int insertOdersubscription(String orderIdByTime, String mobile, String subscriptionid, String start, String price);
}




